{
  "statement":"select  count(*) from (\n    select distinct c_last_name, c_first_name, d_date\n    from store_sales, date_dim, customer\n          where store_sales.ss_sold_date_sk \u003d date_dim.d_date_sk\n      and store_sales.ss_customer_sk \u003d customer.c_customer_sk\n      and d_month_seq between 1200 and 1200 + 11\n  intersect\n    select distinct c_last_name, c_first_name, d_date\n    from catalog_sales, date_dim, customer\n          where catalog_sales.cs_sold_date_sk \u003d date_dim.d_date_sk\n      and catalog_sales.cs_bill_customer_sk \u003d customer.c_customer_sk\n      and d_month_seq between 1200 and 1200 + 11\n  intersect\n    select distinct c_last_name, c_first_name, d_date\n    from web_sales, date_dim, customer\n          where web_sales.ws_sold_date_sk \u003d date_dim.d_date_sk\n      and web_sales.ws_bill_customer_sk \u003d customer.c_customer_sk\n      and d_month_seq between 1200 and 1200 + 11\n) hot_cust\nlimit 100;\n",
  "table_meta":{
    "tpcds.catalog_sales":"CREATE TABLE `catalog_sales` (\n  `cs_item_sk` int(11) NOT NULL COMMENT \"\",\n  `cs_order_number` int(11) NOT NULL COMMENT \"\",\n  `cs_sold_date_sk` int(11) NULL COMMENT \"\",\n  `cs_sold_time_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_date_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_customer_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_addr_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_customer_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_addr_sk` int(11) NULL COMMENT \"\",\n  `cs_call_center_sk` int(11) NULL COMMENT \"\",\n  `cs_catalog_page_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `cs_warehouse_sk` int(11) NULL COMMENT \"\",\n  `cs_promo_sk` int(11) NULL COMMENT \"\",\n  `cs_quantity` int(11) NULL COMMENT \"\",\n  `cs_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_discount_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_coupon_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_ship_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_paid` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_ship` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_ship_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_profit` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`cs_item_sk`, `cs_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`cs_item_sk`, `cs_order_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.store_sales":"CREATE TABLE `store_sales` (\n  `ss_item_sk` int(11) NOT NULL COMMENT \"\",\n  `ss_ticket_number` int(11) NOT NULL COMMENT \"\",\n  `ss_sold_date_sk` int(11) NULL COMMENT \"\",\n  `ss_sold_time_sk` int(11) NULL COMMENT \"\",\n  `ss_customer_sk` int(11) NULL COMMENT \"\",\n  `ss_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ss_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ss_addr_sk` int(11) NULL COMMENT \"\",\n  `ss_store_sk` int(11) NULL COMMENT \"\",\n  `ss_promo_sk` int(11) NULL COMMENT \"\",\n  `ss_quantity` int(11) NULL COMMENT \"\",\n  `ss_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_discount_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_coupon_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_net_paid` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_net_paid_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_net_profit` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ss_item_sk`, `ss_ticket_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ss_item_sk`, `ss_ticket_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.date_dim":"CREATE TABLE `date_dim` (\n  `d_date_sk` int(11) NOT NULL COMMENT \"\",\n  `d_date_id` char(16) NOT NULL COMMENT \"\",\n  `d_date` date NULL COMMENT \"\",\n  `d_month_seq` int(11) NULL COMMENT \"\",\n  `d_week_seq` int(11) NULL COMMENT \"\",\n  `d_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_year` int(11) NULL COMMENT \"\",\n  `d_dow` int(11) NULL COMMENT \"\",\n  `d_moy` int(11) NULL COMMENT \"\",\n  `d_dom` int(11) NULL COMMENT \"\",\n  `d_qoy` int(11) NULL COMMENT \"\",\n  `d_fy_year` int(11) NULL COMMENT \"\",\n  `d_fy_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_fy_week_seq` int(11) NULL COMMENT \"\",\n  `d_day_name` char(9) NULL COMMENT \"\",\n  `d_quarter_name` char(6) NULL COMMENT \"\",\n  `d_holiday` char(1) NULL COMMENT \"\",\n  `d_weekend` char(1) NULL COMMENT \"\",\n  `d_following_holiday` char(1) NULL COMMENT \"\",\n  `d_first_dom` int(11) NULL COMMENT \"\",\n  `d_last_dom` int(11) NULL COMMENT \"\",\n  `d_same_day_ly` int(11) NULL COMMENT \"\",\n  `d_same_day_lq` int(11) NULL COMMENT \"\",\n  `d_current_day` char(1) NULL COMMENT \"\",\n  `d_current_week` char(1) NULL COMMENT \"\",\n  `d_current_month` char(1) NULL COMMENT \"\",\n  `d_current_quarter` char(1) NULL COMMENT \"\",\n  `d_current_year` char(1) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`d_date_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`d_date_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.customer":"CREATE TABLE `customer` (\n  `c_customer_sk` int(11) NOT NULL COMMENT \"\",\n  `c_customer_id` char(16) NOT NULL COMMENT \"\",\n  `c_current_cdemo_sk` int(11) NULL COMMENT \"\",\n  `c_current_hdemo_sk` int(11) NULL COMMENT \"\",\n  `c_current_addr_sk` int(11) NULL COMMENT \"\",\n  `c_first_shipto_date_sk` int(11) NULL COMMENT \"\",\n  `c_first_sales_date_sk` int(11) NULL COMMENT \"\",\n  `c_salutation` char(10) NULL COMMENT \"\",\n  `c_first_name` char(20) NULL COMMENT \"\",\n  `c_last_name` char(30) NULL COMMENT \"\",\n  `c_preferred_cust_flag` char(1) NULL COMMENT \"\",\n  `c_birth_day` int(11) NULL COMMENT \"\",\n  `c_birth_month` int(11) NULL COMMENT \"\",\n  `c_birth_year` int(11) NULL COMMENT \"\",\n  `c_birth_country` varchar(20) NULL COMMENT \"\",\n  `c_login` char(13) NULL COMMENT \"\",\n  `c_email_address` char(50) NULL COMMENT \"\",\n  `c_last_review_date` char(10) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`c_customer_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`c_customer_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.web_sales":"CREATE TABLE `web_sales` (\n  `ws_item_sk` int(11) NOT NULL COMMENT \"\",\n  `ws_order_number` int(11) NOT NULL COMMENT \"\",\n  `ws_sold_date_sk` int(11) NULL COMMENT \"\",\n  `ws_sold_time_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_date_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_customer_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_addr_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_customer_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_addr_sk` int(11) NULL COMMENT \"\",\n  `ws_web_page_sk` int(11) NULL COMMENT \"\",\n  `ws_web_site_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `ws_warehouse_sk` int(11) NULL COMMENT \"\",\n  `ws_promo_sk` int(11) NULL COMMENT \"\",\n  `ws_quantity` int(11) NULL COMMENT \"\",\n  `ws_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_discount_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_coupon_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_ship_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_paid` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_ship` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_ship_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_profit` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ws_item_sk`, `ws_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ws_item_sk`, `ws_order_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);"
  },
  "table_row_count":{
    "tpcds.customer":{
      "customer":2000000
    },
    "tpcds.store_sales":{
      "store_sales":287997024
    },
    "tpcds.catalog_sales":{
      "catalog_sales":143997065
    },
    "tpcds.web_sales":{
      "web_sales":71913344
    },
    "tpcds.date_dim":{
      "date_dim":73049
    }
  },
  "session_variables":"{\"runtime_join_filter_push_down_limit\":1024000,\"codegen_level\":0,\"cbo_cte_reuse\":false,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_filter_unused_columns_in_scan_stage\":false,\"div_precision_increment\":4,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"auto_increment_increment\":1,\"foreign_key_checks\":true,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":false,\"character_set_results\":\"utf8\",\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"cbo_enable_dp_join_reorder\":true,\"cbo_enable_low_cardinality_optimize\":false,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"new_planner_optimize_timeout\":3000,\"force_schedule_local\":false,\"pipeline_dop\":4,\"enable_query_dump\":false,\"cbo_enable_greedy_join_reorder\":true,\"prefer_join_method\":\"broadcast\",\"load_mem_limit\":0,\"sql_select_limit\":9223372036854775807,\"profiling\":false,\"sql_safe_updates\":0,\"enable_pipeline_engine\":true,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"pipeline_profile_level\":1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"normal\",\"enable_new_planner_push_down_join_to_agg\":false,\"broadcast_row_limit\":15000000,\"exec_mem_limit\":10000000000000,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":false,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"enable_vectorized_insert\":true,\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"cbo_enable_replicated_join\":true,\"max_allowed_packet\":1048576,\"query_timeout\":100000,\"enable_cbo\":true,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"max_execution_time\":3000000,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"sql_mode\":2,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false}",
  "column_statistics":{
    "tpcds.customer":{
      "c_customer_sk":"[2.0, 1000596.0, 0.0, 4.0, 2000000.0] ESTIMATE",
      "c_last_name":"[-Infinity, Infinity, 0.035395, 5.916745, 5000.0] ESTIMATE",
      "c_first_name":"[-Infinity, Infinity, 0.034735, 5.639865, 4745.0] ESTIMATE"
    },
    "tpcds.store_sales":{
      "ss_customer_sk":"[6.0, 1999992.0, 0.04473, 4.0, 1296341.0] ESTIMATE",
      "ss_sold_date_sk":"[2450816.0, 2452642.0, 0.045245, 4.0, 1824.0] ESTIMATE"
    },
    "tpcds.catalog_sales":{
      "cs_sold_date_sk":"[2450815.0, 2452654.0, 0.005075, 4.0, 1837.0] ESTIMATE",
      "cs_bill_customer_sk":"[8.0, 1999999.0, 0.005015, 4.0, 1723505.0] ESTIMATE"
    },
    "tpcds.web_sales":{
      "ws_sold_date_sk":"[2450816.0, 2452642.0, 1.9E-4, 4.0, 1824.0] ESTIMATE",
      "ws_bill_customer_sk":"[20.0, 1999983.0, 2.2E-4, 4.0, 1517228.0] ESTIMATE"
    },
    "tpcds.date_dim":{
      "d_date":"[-2.208931543E9, 4.102416E9, 0.0, 4.0, 72542.0] ESTIMATE",
      "d_month_seq":"[0.0, 2400.0, 0.0, 4.0, 2398.0] ESTIMATE",
      "d_date_sk":"[2415022.0, 2488070.0, 0.0, 4.0, 72542.0] ESTIMATE"
    }
  },
  "be_number":3,
  "exception":[

  ]
}
